package com.qckj.amz.domain;

import com.qckj.common.annotation.Excel;
import com.qckj.common.core.domain.BaseEntity;
import lombok.Data;

import javax.persistence.*;
import java.math.BigDecimal;
import java.util.Date;

/**
 * 订单项信息对象 t_order_item
 *
 * @author luchuan
 * @since 1.0 2021-11-27
 */
@Entity
@Table(name = "t_order_item")
@Data
public class OrderItem extends BaseEntity {

    private static final long serialVersionUID = 1L;

    /** 主键自增 */
    @Excel(name = "操作序号", cellType = Excel.ColumnType.NUMERIC)
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Id
    @Column(name="order_item_id")
    private Long orderItemId;

    /** 亚马逊订单编号 */
    @Excel(name = "亚马逊订单编号")
    @Column(name="amazon_order_id")
    private String amazonOrderId;

    /** 产品标题 */
    @Excel(name = "产品标题")
    @Column(name="title")
    private String title;

    /** 产品ASIN */
    @Excel(name = "产品ASIN")
    @Column(name="asin")
    private String asin;

    /** 产品SKU */
    @Excel(name = "产品SKU")
    @Column(name="seller_sku")
    private String sellerSku;

    /** 订购数量 */
    @Excel(name = "订购数量")
    @Column(name="quantity_ordered")
    private Integer quantityOrdered;


    /** 售价货币 */
    @Excel(name = "售价货币")
    @Column(name="money_currency_code")
    private String moneyCurrencyCode;

    /** 售价 */
    @Excel(name = "售价")
    @Column(name="money_item_price")
    private BigDecimal moneyItemPrice;

    /** 运费 */
    @Excel(name = "运费")
    @Column(name="money_shipping_price")
    private BigDecimal moneyShippingPrice;

    /** 产品税 */
    @Excel(name = "产品税")
    @Column(name="money_item_tax")
    private BigDecimal moneyItemTax;

    /** 物流税 */
    @Excel(name = "物流税")
    @Column(name="money_shipping_tax")
    private BigDecimal moneyShippingTax;

    /** 创建人 */
    @Column(name="create_by")
    private String createBy;

    /** 创建时间 */
    @Column(name="create_time")
    private Date createTime;

    /** 更新人 */
    @Column(name="update_by")
    private String updateBy;

    /** 更新时间 */
    @Column(name="update_time")
    private Date updateTime;

    /** 备注 */
    @Excel(name = "备注")
    @Column(name="remark")
    private String remark;


}
